package com.itheima.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.sql.Date;
import java.time.LocalDate;

@Mapper
public interface MemberDao {
    //获取总数
    @Select("select count(*) from t_member where name is not null and regTime <=#{date};")
    Integer getAllCount(Date date);

    //获取范围日期 计数
    @Select("select count(*) from t_member where name is not null and regTime >= #{start} and regTime <= #{end};")
    Integer getAddCount(LocalDate start, LocalDate end);
}
